DEBUG SQL FINAL ITEMS:
SELECT DISTINCT i.*,
CASE WHEN i.modified = 0 THEN i.created ELSE i.modified END AS lastChanged,
c.name AS categoryname,
c.id AS categoryid,
c.alias AS categoryalias,
c.params AS categoryparams
FROM #__k2_items AS i
RIGHT JOIN #__k2_categories AS c ON c.id = i.catid
/* demais LEFT JOINs (tags, rating, etc.) */
WHERE i.published = 1 AND i.access IN(1,1,5) AND i.trash = 0 AND c.published = 1 AND c.access IN(1,1,5) AND c.trash = 0 AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-05-13 00:01:21' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-05-13 00:01:21' ) ORDER BY i.created DESC